UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Q/6cmULUFjmx0WAGBMXu9Kp/AGXD014Bl4A2V3KihA='
WHERE
key_id = '3f7c78a8fb4881223f20c0789367d5cee17b41fc186df025d80758d2258eb0df'
AND (
token = '/Q/6cmULUFjmx0WAGBMXu9Kp/AGXD014Bl4A2V3KihA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)