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