UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YVP7Kw0F9QLCUzknHPkJ4CxtL+Ad8pTys6E3ixxhHFw='
WHERE
key_id = '747c4773ff71296c07a44794eda4fdf6791311ff83102dd5da1b1f9101d6ea49'
AND (
token = 'YVP7Kw0F9QLCUzknHPkJ4CxtL+Ad8pTys6E3ixxhHFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)