UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9YN4dWNDb2jkFpCLr4g57aOZNw8wSJ0T/nPB55ehUJo='
WHERE
key_id = '00ef08633868bd61e3518f5dca8d14b1fdb5a50824e2d8f892b72a9e9fcb4678'
AND (
token = '9YN4dWNDb2jkFpCLr4g57aOZNw8wSJ0T/nPB55ehUJo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)