UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cbIjWmMQWT1hhtTDcaU6WNymxD+J7RS01R6dmd7pkXE='
WHERE
key_id = 'a7e8fd1b5b4abbd0e0025a1f97c33806b8b8361383a4c6467100d65ecc1781fc'
AND (
token = 'cbIjWmMQWT1hhtTDcaU6WNymxD+J7RS01R6dmd7pkXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)