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