UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZfLsrjJcZwY9x2JSxQX8s7FwK0hbIgeUKiUQEPyDwaY='
WHERE
key_id = 'e0f3784fa15e36ead4dc0fd4ba6a02fc64e6279dc54bc841d0d77fcb82b7f6a4'
AND (
token = 'ZfLsrjJcZwY9x2JSxQX8s7FwK0hbIgeUKiUQEPyDwaY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)