UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N039WwKy2c2fxSRIr9hjJ/O2I1Y77oxVOasSya3JeMo='
WHERE
key_id = 'f78dee3e936fe3016e440848ca9d977b69e6b833d7e7ecdf38b5d65725520854'
AND (
token = 'N039WwKy2c2fxSRIr9hjJ/O2I1Y77oxVOasSya3JeMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)