UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZhQhmGKGTSogyeBoUW/4UJCQFv//V3dVdw/1sW4jCzE='
WHERE
key_id = 'a5143b2c9be2cf54541751e866e625e3f785591a4db3511c383253539b53c616'
AND (
token = 'ZhQhmGKGTSogyeBoUW/4UJCQFv//V3dVdw/1sW4jCzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)