UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nxKrOQfLESa7B/LAfqLzLE7cYVnEOWavX/u0W10T86Q='
WHERE
key_id = 'ecdad341b216c98ccf2032905bed811b406c25097150e326e8c47fca8ef7046c'
AND (
token = 'nxKrOQfLESa7B/LAfqLzLE7cYVnEOWavX/u0W10T86Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)