UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZPlZgyIUpFGBG5tt3gWO83SJg00DDYBVo5TSQIg1Ato='
WHERE
key_id = '8ae0f799d3de7c67ea6539e3ee89e5a91c43550cfa9830728ef6d1ce679e4376'
AND (
token = 'ZPlZgyIUpFGBG5tt3gWO83SJg00DDYBVo5TSQIg1Ato='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)