UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LgD2y3hkO0RlP6jTzJIiWion0GhvhoTeECln+H/S2fA='
WHERE
key_id = '4059dc136e370f1e8cf9d495233f61d3c1f78ab140df654a557f5e4133adb987'
AND (
token = 'LgD2y3hkO0RlP6jTzJIiWion0GhvhoTeECln+H/S2fA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)