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