UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fHfafEJey8OeMeomsHQD/ZiVrdqPy2MmW8oNEb9iFcc='
WHERE
key_id = 'a8a65cb515191c255098d236adac174a9003eb809ebd88edb376e4c8ac1d0601'
AND (
token = 'fHfafEJey8OeMeomsHQD/ZiVrdqPy2MmW8oNEb9iFcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)