UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JGgXvGhV0LJW4FZdXcSN0iAXOtO5M1iGjhK56moEng4='
WHERE
key_id = '959712fb5932e38b9f899866217b3e33f93e068c809063b179d79a9c9575100a'
AND (
token = 'JGgXvGhV0LJW4FZdXcSN0iAXOtO5M1iGjhK56moEng4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)