UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XM31njFtedPH+W8cqpIc3jIleTvu0kwJ7bVAwF4xpc='
WHERE
key_id = 'f365566de3763a446de055d698b80cb2e10e128c6153d7a5c0b511abe861fcdb'
AND (
token = '/XM31njFtedPH+W8cqpIc3jIleTvu0kwJ7bVAwF4xpc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)