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