UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U+H4wgRm5eUvAnUzJsfY91x2lcdxAYAxWocDGlx//4I='
WHERE
key_id = 'c0714b4ce489d66d36c81a3269af750813974dd37c1c55a0260b26f471096877'
AND (
token = 'U+H4wgRm5eUvAnUzJsfY91x2lcdxAYAxWocDGlx//4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)