UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '49cXdBbuyzR6RESRjTTRa6OpB31gvykUmlj4re2rmP0='
WHERE
key_id = '99638277a3165032b8a4865e2b5d3297f1bfc98ee2c007c3b12abeee4984fdaf'
AND (
token = '49cXdBbuyzR6RESRjTTRa6OpB31gvykUmlj4re2rmP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)