UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7s4V9p3B7eowpjVz4wI9XMOEr2Uf0mKRNydEuCdUx6Y='
WHERE
key_id = '8f6a178e8caca07cba9025f5408ad4122997a4b19932507055454b159b4fa206'
AND (
token = '7s4V9p3B7eowpjVz4wI9XMOEr2Uf0mKRNydEuCdUx6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)