UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ye235ofJTzwqK+9Px9Zu5g+9gcgEVSCIjwadWMkcEY='
WHERE
key_id = '93e65729d2f70baf87f5c56307b6bfe2104e4c5b53cff5e4ebe436e33a9bb8bf'
AND (
token = '1ye235ofJTzwqK+9Px9Zu5g+9gcgEVSCIjwadWMkcEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)