UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tC0qPequ1hziRNO9SRZADgFWXI5/q9Akzo1P77Um2qE='
WHERE
key_id = '38d493922f7bb97f22bfea8f99f76bb818f80b85abed86ce5183d021880fa684'
AND (
token = 'tC0qPequ1hziRNO9SRZADgFWXI5/q9Akzo1P77Um2qE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)