UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I9YqNMBmclY7p48msIrPjCW8ezhM3ijun4M/4iuz+/I='
WHERE
key_id = 'be85a7320efa7920e49b72e40bc40e6543a297992c0c888f84b092fd3d7b6007'
AND (
token = 'I9YqNMBmclY7p48msIrPjCW8ezhM3ijun4M/4iuz+/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)