UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aX0yLdxozNVxEQqmOtwtOhD7+9XRekT92H5nhDmvCvo='
WHERE
key_id = '0d9890c67ac10db2cd8fe88edf5c53d96e639e8736d5bcf9916b495300289612'
AND (
token = 'aX0yLdxozNVxEQqmOtwtOhD7+9XRekT92H5nhDmvCvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)