UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pESwcOmNXUgZ0AknmgVSD4v7IolWhtKRmidpcDoS+uE='
WHERE
key_id = 'ac6f0ebd867f9f04c705a985bfc27f3dd4ab18804493cd3b1f9ab22eedd5ba29'
AND (
token = 'pESwcOmNXUgZ0AknmgVSD4v7IolWhtKRmidpcDoS+uE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)