UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E1HIHRljI7aVL2rL2WZnVlByCrFG4qFokrSdadF4cTs='
WHERE
key_id = 'b7fb359f4e4f0110141c48e2ef5c7bfc24496daa12b6eb5e446b9ae68ed38783'
AND (
token = 'E1HIHRljI7aVL2rL2WZnVlByCrFG4qFokrSdadF4cTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)