UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K3PjTHzHV71NHJ8usypHuRmMZsDXZ899OcUj7meOiYI='
WHERE
key_id = '5e594c72483fe64de072c907bee7d3a9fd4b81196a447ffb6340a220de06df02'
AND (
token = 'K3PjTHzHV71NHJ8usypHuRmMZsDXZ899OcUj7meOiYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)