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