UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AZvOYcRnUoP7acU2acFWDLu7LRM0ZAWVNa8xjEEujv8='
WHERE
key_id = 'bdf3664cf53ae81ed77def910f6097b0ba271d4b3401898e15d76959dee8eecc'
AND (
token = 'AZvOYcRnUoP7acU2acFWDLu7LRM0ZAWVNa8xjEEujv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)