UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6YPkN0SLjnM7aV7vijCaSJa/XGoU5LW6mJo2AdpyBCw='
WHERE
key_id = '07d2a0e6d23e37aa70cee4e2b50c54a37d57a3c59ab56f5395e9ec64185cc830'
AND (
token = '6YPkN0SLjnM7aV7vijCaSJa/XGoU5LW6mJo2AdpyBCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)