UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xTpPOI+wTqxLTymI3EDepeQv79lUU2Dr9rqtZysS8SE='
WHERE
key_id = 'c708d861dedd946ff72abb6818b3740d1f1171af3e24e17860ef5fcedb5cddd5'
AND (
token = 'xTpPOI+wTqxLTymI3EDepeQv79lUU2Dr9rqtZysS8SE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)