UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZdMuTR06Sh8LiI8nln6Q+XYY7t/CHzkb1Jahs6sV+uM='
WHERE
key_id = 'b1de767bb23ba20a0893b4a1285ac1afddfa4814fe0ee522bb8978299b65c027'
AND (
token = 'ZdMuTR06Sh8LiI8nln6Q+XYY7t/CHzkb1Jahs6sV+uM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)