UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GDdqcR0ti9onw51/fTa1o+fM3zBSHsLQMk/+SH8Xbao='
WHERE
key_id = 'c3c133e53e89ec5c02777d5ea0c190214dd0b296fc4fcde22521338e8d6b8cf0'
AND (
token = 'GDdqcR0ti9onw51/fTa1o+fM3zBSHsLQMk/+SH8Xbao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)