UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '55fc372yoJSZPVSp7LJShEHuU30cvDVQcVmxTn5e++U='
WHERE
key_id = '9e8253ec1c9f3c81e9172a797322d53e51fe57fe9e35c97c8133752078f1d6f1'
AND (
token = '55fc372yoJSZPVSp7LJShEHuU30cvDVQcVmxTn5e++U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)